﻿CREATE TABLE [dbo].[t_LoanInfo_Snapshot] (
    [LoanID]               INT             NOT NULL,
    [SnapshotName]         VARCHAR (32)    NOT NULL,
    [AmountFinanced]       NUMERIC (9, 2)  NULL,
    [APROverride]          NUMERIC (18, 3) NULL,
    [ContractDate]         SMALLDATETIME   NULL,
    [FirstPaymentDate]     SMALLDATETIME   NULL,
    [AddOnRateOverride]    NUMERIC (4, 2)  NULL,
    [PaymentOverride]      NUMERIC (6, 2)  NULL,
    [IsRule78]             BIT             NOT NULL,
    [InterestType]         TINYINT         NULL,
    [PaymentsPerYear]      TINYINT         NOT NULL,
    [NumberOfPayments]     SMALLINT        NULL,
    [AuctionPrice]         INT             NULL,
    [Proceeds]             INT             NULL,
    [DayCountConventionID] TINYINT         NOT NULL
);

